<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

defined('IN_ADMIN') or die('Hacking Attempt!');

func::isLogin();

$iOrderId = (isset($_GET['id']) && is_numeric($_GET['id'])) ? $_GET['id'] : 0;

$sSql = 'SELECT * FROM tnf.order WHERE orderId='. $iOrderId;
$aResult = mysql::querySql($sSql);
$aRow = mysql::fetchSql($aResult);

$sSql = 'SELECT * FROM customer WHERE customerId='. $aRow['customerId'];
$aResult = mysql::querySql($sSql);
$aCustomerRow = mysql::fetchSql($aResult);

$sSql = 'SELECT amount FROM debit WHERE customerId='. $aRow['customerId'];
$aResult = mysql::querySql($sSql);
$aDebitRow = mysql::fetchSql($aResult);
?>
